<div id="main">
	<div id="content">
        <div id="subcategory">
            <h2>品牌：</h2>
            <ul>
                  <li><a href="#">大众</a></li>
                  <li><a href="#">丰田</a></li>
                  <li><a href="#">吉利</a></li>
                  <li><a href="#">海马</a></li>
                  <li><a href="#">奥迪</a></li>
                  <li><a href="#">劳斯莱斯</a></li>
                  <li><a href="#">雷克萨斯</a></li>
                  <li><a href="#">本田</a></li>
                  <li><a href="#">英菲尼迪</a></li>
                  <li><a href="#">凯迪拉克</a></li>
                  <li><a href="#">奇瑞</a></li>
                  <li><a href="#">大众</a></li>
                  <li><a href="#">丰田</a></li>
                  <li><a href="#">吉利</a></li>
                  <li><a href="#">海马</a></li>
                  <li><a href="#">奥迪</a></li>
                  <li><a href="#">劳斯莱斯</a></li>
                  <li><a href="#">雷克萨斯</a></li>
                  <li><a href="#">本田</a></li>
                  <li><a href="#">英菲尼迪</a></li>
                  <li><a href="#">凯迪拉克</a></li>
                  <li><a href="#">奇瑞</a></li>
                  <li><a href="#">大众</a></li>
                  <li><a href="#">丰田</a></li>
                  <li><a href="#">吉利</a></li>
                  <li><a href="#">海马</a></li>
                  <li><a href="#">奥迪</a></li>
                  <li><a href="#">劳斯莱斯</a></li>
                  <li><a href="#">雷克萨斯</a></li>
                  <li><a href="#">本田</a></li>
                  <li><a href="#">英菲尼迪</a></li>
                  <li><a href="#">凯迪拉克</a></li>
                  <li><a href="#">奇瑞</a></li>
            </ul>
            <div class="clear"></div>
            <a href="#" class="more">more</a>
        </div>
        
        <div class="homeplist" id="hotplist">
        <h2><a href="#">more</a>热卖车型</h2>     
          <ul>
               <?php
               $i=1;
           $link= mysqli_connect("localhost","root","");
            mysqli_select_db($link, "nhcar");
            mysqli_set_charset($link, "utf8");
//            $sql="SELECT * FROM shop_goods WHERE recommend='yes'";
             $sql="SELECT * FROM product WHERE pischeap=1;";
           $result=  mysqli_query($link,$sql);
           while ($row=  mysqli_fetch_assoc($result)){
            $pid=$row['pid'];
            $pname=$row['pname'];
            $pprice=$row['pprice'];
            $ppic=$row['ppic'];
            ?>
                <li><a href="#"><img src="images/p<?php echo "$i";?>.jpg"/></a>
                    <h3><a href="#"><?php echo $pname;?></a></h3>
                    <p><a href="#">立即抢购</a><?php echo $pprice; ?></p>
                </li>
        <?php
        $i++;
        }
        ?>
          </ul>
        </div>
        <div class="homeplist" id="newplist">
        <h2><a href="#">more</a>新车上市</h2>
        <ul>
         <?php
               $i=1;
           $link= mysqli_connect("localhost","root","");
            mysqli_select_db($link, "nhcar");
            mysqli_set_charset($link, "utf8");
//            $sql="SELECT * FROM shop_goods WHERE recommend='yes'";
             $sql="SELECT * FROM product WHERE pischeap=1;";
           $result=  mysqli_query($link,$sql);
           while ($row=  mysqli_fetch_assoc($result)){
            $pid=$row['pid'];
            $pname=$row['pname'];
            $pprice=$row['pprice'];
            $ppic=$row['ppic'];
            ?>
                <li><a href="#"><img src="images/p<?php echo "$i";?>.jpg"/></a>
                    <h3><a href="#"><?php echo $pname;?></a></h3>
                    <p><a href="#">立即抢购</a><?php echo $pprice; ?></p>
                </li>
        <?php
        $i++;
        }
        ?>

        </ul>
        </div>
        <div class="homeplist" id="cheapplist">
        <h2><a href="#">more</a>促销车型</h2>
        <ul>
          <?php
               $i=1;
           $link= mysqli_connect("localhost","root","");
            mysqli_select_db($link, "nhcar");
            mysqli_set_charset($link, "utf8");
//            $sql="SELECT * FROM shop_goods WHERE recommend='yes'";
             $sql="SELECT * FROM product WHERE pischeap=1;";
           $result=  mysqli_query($link,$sql);
           while ($row=  mysqli_fetch_assoc($result)){
            $pid=$row['pid'];
            $pname=$row['pname'];
            $pprice=$row['pprice'];
            $ppic=$row['ppic'];
            ?>
                <li><a href="#"><img src="images/p<?php echo "$i";?>.jpg"/></a>
                    <h3><a href="#"><?php echo $pname;?></a></h3>
                    <p><a href="#">立即抢购</a><?php echo $pprice; ?></p>
                </li>
        <?php
        $i++;
        }
        ?>

        </ul>
        </div>
    </div>
</div>